Creating a CSV Report
In this example, we will use the Employees table within the sample database to create a CSV report. The table contains the following fields which are all used in the Report query.
Field name | Description |
---|---|
emp_id | Employee Number |
last_name | Employee Last Name |
first_name | Employee First Name |
hire_date | Hire Date |
salary | Salary |
dept_id | Department ID |
location_id | Location ID (a department can exist in several locations) |
Street_Line1 | 1st line of address |
Street_Line2 | 2nd line of address |
Street_Line3 | 3rd line of address |
city | City |
state | State |
zip | Zip Code |